Skip to main content

CEILING.PRECISE function

The CEILING.PRECISE function rounds a number up to the nearest integer or multiple of specified significance. If the number is positive or negative, it's rounded up.

Parts of a CEILING.PRECISE formula​

CEILING.PRECISE(number, [significance])

PartDescriptionNotes
numberThe value to round up to the nearest integer or multiple ofsignificance.
significanceThe number to whose multiplesnumber will be rounded. The sign of significance will be ignored.[OPTIONAL: 1 by default]

Sample formulas​

CEILING.PRECISE(-10.5, 1)<br/>CEILING.PRECISE(96, 10)<br/>CEILING.PRECISE(-23.25, 0.1)

Notes​

  • By default, positive numbers with decimal places are rounded up to the nearest integer. For example, 4.3 is rounded up to 5.
  • Negative numbers are rounded up (toward zero). For example, -4.3 is rounded up to -4.

Examples​

AB
1FormulaResult
2=CEILING.PRECISE(-10.5, 1)-10
3=CEILING.PRECISE(96, 10)100
4=CEILING.PRECISE(-23.25, 0.1)23.2
  • CEILING: The CEILING function rounds a number up to the nearest integer multiple of specified significance.
  • CEILING.MATH: The CEILING.MATH function rounds a number up to the nearest integer or to the nearest multiple of specified significance. It also specifies whether the number is rounded toward or away from 0 depending on the mode.
  • ROUNDUP: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
  • ROUND: The ROUND function rounds a number to a certain number of decimal places according to standard rules.
  • FLOOR: The FLOOR function rounds a number down to the nearest integer multiple of specified significance.
  • FLOOR.MATH: The FLOOR.MATH function rounds a number down to the nearest integer or a multiple of specified significance, with negative numbers rounding toward or away from zero depending on the mode.
  • FLOOR.PRECISE: The FLOOR.PRECISE functions rounds a number down to the nearest integer or multiple of specified significance.